Hi,

Excel returns "Data not available"

when the parameter value is specified as a range of cells

Wireshark shows that the query uses plus signs as separators rather than commas

9 3.725510000 192.168.0.2 204.79.197.203 HTTP 1907 GET /en-us/money/quoteslookup?SYMBOL=MSFT+AAPL+IBM HTTP/1.1

The URL for the request is
 
http://www.msn.com/en-us/money/quoteslookup?SYMBOL=MSFT+AAPL+IBM

Below is information about what already works.

Excel returns the requested data when the parameter value is specified as a comma-separated list.

In this case Wireshark shows that the query uses commas as separators

9 4.625964000 192.168.0.2 204.79.197.203 HTTP 1907 GET /en-us/money/quoteslookup?SYMBOL=MSFT,AAPL,IBM HTTP/1.1

The URL for the request is

http://www.msn.com/en-us/money/quoteslookup?SYMBOL=MSFT,AAPL,IBM

It should be possible to specify the parameter list as either a comma-separated list or as a range of cells.  Please make it possible to specify the parameter values as a range of cells.

Thanks,

Norman

Is anyone actually looking at this question?  If you have the same problem, please add a reply.

Thanks,

Norman

Good News: 

It appears that someone has made changes to the parameter parsing recently to allow the separator to be either comma or plus sign as I requested.  This means that using a range of cells as described above should now work.

Bad News: 

Every time a change is made to the parameter parsing code something that used to work no longer works.  This is not fatal but requires frequent small tweaks to keep everything working as desired.

Prior to the most recent change I used a parameter string

NWSA,Prudential Financial,Southern,US00206R1023

to get the US traded stocks NWSA, PRU, SO, and T.

The change today changed the fetch from Prudential (the US version) to PRUDENTIAL PLC and FINANCIAL SEL SECT SPDR FD (2 separate quotes).  Not what I desired.  The "fix" was to use the PRU ISIN US7443201022 for the quote I wanted.  Perhaps, blank(s) should not be separators.

For anyone asking what is an ISIN and where do I get it (as I did recently), I can share the following:

1)  ISIN stands for International Securities Identification Number and for US stocks consists of the letters "US", the CUSIP (Committee on Uniform Securities Identification Procedures), and a check digit. 

2)  The ISIN determines the security not the exchange where it is traded.  In thread https://social.technet.microsoft.com/Forums/office/en-US/400e5154-bdf2-48ca-b269-dddbbf713e8b/msn-money-stock-quotes-mystery?forum=excel user tekoko10 reports that using BE:BE0003817344 got him the correct security and the correct exchange.

3)  Where to get the CUSIP for a stock: try http://quantumonline.com/

4)  Where to get the ISIN for a stock: try http://www.advfn.com/exchanges/NYSE/CBS/stock-price  Clearly you will have to adjust the URL to get what you want.

5)  It seems that specifying the ISIN without the check digit also works.  This is nice since calculating the check digit is somewhat painful.

As always, I wonder if anyone ever sees this thread.

Good luck,

Norman

• Edited by NFFATX 10 hours 39 minutes ago Add cooma

Good News: 

It appears that someone has made changes to the parameter parsing recently to allow the separator to be either comma or plus sign as I requested.  This means that using a range of cells as described above should now work.

Bad News: 

Every time a change is made to the parameter parsing code something that used to work no longer works.  This is not fatal but requires frequent small tweaks to keep everything working as desired.

Prior to the most recent change I used a parameter string

NWSA,Prudential Financial,Southern,US00206R1023

to get the US traded stocks NWSA, PRU, SO, and T.

The change today changed the fetch from Prudential (the US version) to PRUDENTIAL PLC and FINANCIAL SEL SECT SPDR FD (2 separate quotes).  Not what I desired.  The "fix" was to use the PRU ISIN US7443201022 for the quote I wanted.  Perhaps, blank(s) should not be separators.

For anyone asking what is an ISIN and where do I get it (as I did recently), I can share the following:

1)  ISIN stands for International Securities Identification Number and for US stocks consists of the letters "US", the CUSIP (Committee on Uniform Securities Identification Procedures), and a check digit. 

2)  The ISIN determines the security not the exchange where it is traded.  In thread https://social.technet.microsoft.com/Forums/office/en-US/400e5154-bdf2-48ca-b269-dddbbf713e8b/msn-money-stock-quotes-mystery?forum=excel user tekoko10 reports that using BE:BE0003817344 got him the correct security and the correct exchange.

3)  Where to get the CUSIP for a stock: try http://quantumonline.com/

4)  Where to get the ISIN for a stock: try http://www.advfn.com/exchanges/NYSE/CBS/stock-price  Clearly you will have to adjust the URL to get what you want.

5)  It seems that specifying the ISIN without the check digit also works.  This is nice since calculating the check digit is somewhat painful.

As always, I wonder if anyone ever sees this thread.

Good luck,

Norman

• Edited by NFFATX Friday, March 13, 2015 8:45 PM Add cooma